﻿
CREATE PROCEDURE [dbo].[proc_Order_Finish]
(
	@OId uniqueidentifier,
	@WebAddress varchar(100)
)
AS
Begin
	Update [Order] Set StateId=5,FinishDate=GetDate() Where OId=@OId
	Update Customer Set WebAddress=@WebAddress Where CustomerId In(Select CusId From [Order] Where OId=@OId)
End